exports.standTables = {
  user: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "用户Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "邀请人的Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "invite_id",
        defaultValue: 0,
      },
      {
        type: "char",
        length: 11,
        remark: "电话号码（账号）",
        name: "phone",
      },
      {
        type: "varchar",
        length: 16,
        notNull: true,
        remark: "密码：6~16位字母+数字组合",
        defaultValue: "password123456",
        name: "password",
      },
      {
        type: "varchar",
        length: 10,
        remark: "用户真实姓名",
        name: "user_name",
      },
      {
        type: "varchar",
        length: 16,
        remark: "用户昵称",
        name: "nickname",
      },
      {
        type: "tinyint",
        length: 1,
        remark: "性别 注：0未知 1男 2女",
        defaultValue: 0,
        isUnsigned: true,
        enums: {
          0: "未知",
          1: "男",
          2: "女",
        },
        name: "gender",
      },
      {
        type: "tinyint",
        length: 3,
        remark: "年龄",
        defaultValue: 0,
        isUnsigned: true,
        name: "age",
      },
      {
        name: "role",
        type: "tinyint",
        notNull: true,
        remark: "角色Id（类型）",
        defaultValue: 1,
        isUnsigned: true,
      },
      {
        name: "coin",
        type: "int",
        notNull: true,
        remark: "金币余额",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "vip_type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "会员类型 注：0非会员 1普通会员 2超级会员",
        defaultValue: 0,
        enums: {
          0: "非会员",
          1: "普通会员",
          2: "超级会员",
        },
      },
      {
        type: "datetime",
        remark: "会员到期时间",
        name: "vip_expire",
      },
      {
        name: "status",
        type: "tinyint",
        length: 1,
        notNull: true,
        remark: "账号状态",
        defaultValue: 1,
        isUnsigned: true,
        enum: {
          2: "已注销",
          3: "已封禁",
        },
      },
      {
        type: "varchar",
        length: 100,
        remark: "头像",
        name: "avatar",
      },
      {
        type: "date",
        remark: "出生日期",
        name: "birthday",
      },
      {
        type: "varchar",
        length: 100,
        remark: "邮箱",
        name: "email",
      },
      {
        type: "varchar",
        length: 100,
        name: "produce",
        remark: "个人简介",
      },
      {
        type: "int",
        remark: "经验值",
        defaultValue: 0,
        isUnsigned: true,
        name: "experience",
      },
      {
        type: "json",
        remark: "用户标签",
        name: "tags",
      },
      {
        name: "industry_id",
        type: "smallint",
        notNull: true,
        remark: "行业Id",
        defaultValue: 1,
        isUnsigned: true,
      },
      {
        type: "datetime",
        remark: "最后登录时间",
        name: "last_time",
      },
      {
        type: "varchar",
        length: 16,
        remark: "最后登录IP地址",
        name: "last_ip",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "注册时间",
        name: "create_time",
      },
    ],
    formItems: [
      {
        prop: "id",
        label: "用户I",
        type: "input",
        attrs: {},
        required: true,
      },
      {
        prop: "phone",
        label: "电话号码",
        type: "input",
        attrs: {
          maxlength: 11,
        },
      },
      {
        prop: "user_name",
        label: "用户真实姓",
        type: "input",
        attrs: {
          maxlength: 10,
        },
      },
      {
        prop: "nickname",
        label: "用户昵",
        type: "input",
        attrs: {
          maxlength: 16,
        },
      },
      {
        prop: "gender",
        label: "性",
        type: "select",
        attrs: {
          options: "T_Gender",
        },
      },
      {
        prop: "age",
        label: "年",
        type: "BaseNumberRange",
      },
      {
        prop: "role",
        label: "角色Id",
        type: "BaseNumberRange",
        required: true,
      },
      {
        prop: "status",
        label: "账号状",
        type: "BaseNumberRange",
        required: true,
      },
      {
        prop: "create_time",
        label: "注册时",
        type: "date-picker",
        attrs: {
          type: "datetime",
        },
        required: true,
      },
    ],
    tableCols: [
      {
        prop: "id",
        label: "用户I",
      },
      {
        prop: "phone",
        label: "电话号码",
      },
      {
        prop: "user_name",
        label: "用户真实姓",
      },
      {
        prop: "nickname",
        label: "用户昵",
      },
      {
        prop: "gender",
        label: "性",
        type: "BaseTag",
        attrs: {
          name: "T_Gender",
        },
      },
      {
        prop: "age",
        label: "年",
      },
      {
        prop: "role",
        label: "角色Id",
      },
      {
        prop: "coin",
        label: "金币余",
      },
      {
        prop: "status",
        label: "账号状",
      },
      {
        prop: "create_time",
        label: "注册时",
      },
    ],
    addEditFormItems: [
      {
        prop: "id",
        label: "用户I",
        type: "input",
        attrs: {},
        required: true,
      },
      {
        prop: "phone",
        label: "电话号码",
        type: "input",
        attrs: {
          maxlength: 11,
        },
        required: true,
      },
      {
        prop: "password",
        label: "密码",
        type: "input",
        attrs: {
          maxlength: 16,
        },
        required: true,
      },
      {
        prop: "user_name",
        label: "用户真实姓",
        type: "input",
        attrs: {
          maxlength: 10,
        },
        required: true,
      },
      {
        prop: "nickname",
        label: "用户昵",
        type: "input",
        attrs: {
          maxlength: 16,
        },
      },
      {
        prop: "gender",
        label: "性",
        type: "select",
        attrs: {
          options: "T_Gender",
        },
      },
      {
        prop: "age",
        label: "年",
        type: "input-number",
        attrs: {
          min: 0,
          max: 999,
        },
      },
      {
        prop: "role",
        label: "角色Id",
        type: "input-number",
        attrs: {
          min: 0,
        },
        required: true,
      },
      {
        prop: "coin",
        label: "金币余",
        type: "input-number",
        attrs: {
          min: 0,
        },
        required: true,
      },
      {
        prop: "status",
        label: "账号状",
        type: "input-number",
        attrs: {
          min: 0,
          max: 9,
        },
        required: true,
      },
    ],
    name: "用户",
    insertRows: [
      ["nickname", "userName", "phone", "password", "gender", "age", "role", "vip_type"],
      ["一只小白兔", "李大", "18483221111", "mstx123456", 1, 19, 2, 2],
      ["冰糖雪梨", "王二", "18483221112", "mstx123456", 2, 54, 1, 1],
      ["好名字都被猪起了", "张三", "18483221113", "mstx123456", 0, 26, 0, 1],
      ["唔系唔懂", "李四", "18483221114", "mstx123456", 0, 44, 0, 0],
      ["么么哒呀", "王五", "18483221115", "mstx123456", 2, 34, 0, 0],
      ["你还在等我吗", "李梅", "18483221116", "mstx123456", 1, 24, 0, 0],
    ],
  },
  user_relations: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "主键id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "关注者Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "focus_id",
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "被关注者Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "focused_id",
        defaultValue: 0,
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "用户关系",
    insertRows: [
      ["focus_id", "focused_id"],
      [2, 1],
      [3, 1],
      [4, 1],
      [5, 1],
      [6, 1],
      [1, 2],
      [3, 2],
      [4, 3],
    ],
  },
  visitor: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "主键id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "访客Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "visitor_id",
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "被访问者Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "visited_id",
        defaultValue: 0,
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "访客记录表",
    insertRows: [
      ["visited_id", "visitor_id"],
      [1, 2],
      [1, 3],
      [1, 4],
      [1, 5],
      [2, 1],
      [2, 1],
      [2, 3],
      [2, 4],
      [3, 5],
      [3, 1],
      [3, 2],
      [4, 1],
      [5, 2],
    ],
  },
  system_notice: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "主键id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "接收者Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "accept_id",
        NotNull: true,
        defaultValue: 0,
      },
      {
        name: "type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark:
          "消息类型 注：1系统维护 2平台活动 3意见反馈通知 4举报反馈通知 5被举报通知 6金币奖励发放 11新增粉丝 12点赞 13点踩 14收藏 15分享 16评论 17私信",
        noNull: true,
        enums: {
          1: "系统维护",
          2: "平台活动",
          3: "意见反馈通知",
          4: "举报反馈通知",
          5: "被举报通知",
          6: "金币奖励发放",
          11: "新增粉丝",
          12: "点赞",
          13: "点踩",
          14: "收藏",
          15: "分享",
          16: "评论",
          17: "私信",
        },
        defaultValue: 1,
      },
      {
        name: "is_read",
        type: "tinyint",
        length: 1,
        isUnsigned: true,
        remark: "是否已读",
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "varchar",
        length: 25,
        remark: "消息标题",
        name: "title",
        NotNull: true,
      },
      {
        type: "varchar",
        length: 500,
        name: "content",
        remark: "消息内容",
        NotNull: true,
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "系统消息",
    insertRows: [
      ["accept_id", "type", "title", "content"],
      [1, 1, "系统维护升级", "系统将于xxx至xxx维护升级，给您带来的不便，敬请谅解"],
      [2, 2, "平台活动", "这是平台活动消息的消息内容"],
      [3, 3, "意见反馈通知", "这是意见反馈通知消的消息内容"],
      [4, 4, "举报反馈通知", "这是举报反馈通知消的消息内容"],
      [5, 5, "被举报通知", "这是被举报通知消的消息内容"],
      [6, 6, "金币奖励发放", "这是金币奖励发放消的消息内容"],
      [1, 11, "新增粉丝", "这是新增粉丝消的消息内容"],
      [1, 12, "点赞", "这是点赞消的消息内容"],
      [1, 13, "点踩", "这是点踩消的消息内容"],
      [1, 14, "收藏", "这是收藏消的消息内容"],
      [1, 15, "分享", "这是分享消的消息内容"],
      [1, 16, "评论", "这是评论消的消息内容"],
      [1, 17, "私信", "这是私信消的消息内容"],
    ],
  },
  role: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "角色Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "code",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "标识 注：0普通用户 1普通会员 2超级会员 6普通管理员 7超级管理员",
        enums: {
          0: "普通用户",
          1: "普通会员",
          2: "超级会员",
          6: "普通管理员",
          7: "超级管理员",
        },
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "int",
        remark: "最后修改人",
        isUnsigned: true,
        defaultValue: 0,
        name: "update_id",
      },
      {
        type: "datetime",
        remark: "修改时间",
        name: "update_time",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "角色",
    insertRows: [
      ["code", "create_time", "create_id", "update_time", "update_id"],
      [0, 1748734353122, 1, 1748734385239, 3],
      [1, 1748734353122, 2, 1748734385239, 2],
      [2, 1748734353122, 3, 1748734385239, 3],
      [6, 1748734353122, 4, 1748734385239, 3],
      [7, 1748734353122, 5, 1748734385239, 3],
    ],
  },
  topic: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "题目Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "所属行业Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "industry_id",
        defaultValue: 0,
      },
      {
        type: "varchar",
        length: 255,
        remark: "题目问题",
        name: "title",
        NotNull: true,
      },
      {
        type: "varchar",
        length: 10000,
        name: "content",
        remark: "回答内容",
        NotNull: true,
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "int",
        remark: "最后修改人",
        isUnsigned: true,
        defaultValue: 0,
        name: "update_id",
      },
      {
        type: "datetime",
        remark: "修改时间",
        name: "update_time",
      },
      {
        name: "exposure_num",
        type: "int",
        notNull: true,
        remark: "曝光量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "view_num",
        type: "int",
        notNull: true,
        remark: "浏览量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "comment_num",
        type: "int",
        notNull: true,
        remark: "评论数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "praise_num",
        type: "int",
        notNull: true,
        remark: "点赞数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "belittle_num",
        type: "int",
        notNull: true,
        remark: "点踩数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "collect_num",
        type: "int",
        notNull: true,
        remark: "收藏数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "share_num",
        type: "int",
        notNull: true,
        remark: "分享数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "report_num",
        type: "int",
        notNull: true,
        remark: "举报数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        type: "decimal",
        length: 4,
        decimal: 2,
        remark: "分数，最小0，最大10",
        defaultValue: "10.00",
        name: "score",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "审核Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "audit_id",
        defaultValue: 0,
      },
      {
        type: "tinyint",
        name: "status",
        length: 1,
        notNull: true,
        remark: "启用状态",
        defaultValue: 1,
        isUnsigned: true,
      },
      {
        name: "visible_type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        defaultValue: 0,
        remark: "可见状态 注：0私密 1仅指定用户可见 2仅粉丝可见 3公开",
        enums: {
          0: "私密",
          1: "仅指定用户可见",
          2: "仅粉丝可见",
          3: "公开",
        },
      },
      {
        type: "json",
        remark: "分类标签",
        name: "tags",
      },
      {
        type: "json",
        remark: "历史记录Id",
        name: "history_id",
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "题目",
    insertRows: [
      ["industryId", "title", "content", "createId", "tags"],
      [1, "这是问题1", "这是内容1", 1, "[1,2,3]"],
      [2, "这是问题2", "这是内容2", 2, "[2,3]"],
      [3, "这是问题3", "这是内容3", 3, "[3]"],
      [4, "这是问题4", "这是内容4", 4, "[2,3]"],
      [5, "这是问题5", "这是内容5", 5, "[1,2,3]"],
      [6, "这是问题6", "这是内容6", 6, "[1]"],
      [7, "这是问题7", "这是内容6", 6, "[2]"],
      [8, "这是问题8", "这是内容6", 6, "[2]"],
      [9, "这是问题9", "这是内容6", 6, "[3]"],
      [10, "这是问题10", "这是内容10", 6, "[1,2,3]"],
    ],
  },
  note: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "笔记Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "varchar",
        length: 25,
        remark: "文章（笔记）标题",
        name: "title",
      },
      {
        type: "json",
        remark: "题目Id",
        name: "topic_ids",
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "int",
        remark: "最后修改人",
        isUnsigned: true,
        defaultValue: 0,
        name: "update_id",
      },
      {
        type: "datetime",
        remark: "修改时间",
        name: "update_time",
      },
      {
        name: "exposure_num",
        type: "int",
        notNull: true,
        remark: "曝光量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "view_num",
        type: "int",
        notNull: true,
        remark: "浏览量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "comment_num",
        type: "int",
        notNull: true,
        remark: "评论数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "praise_num",
        type: "int",
        notNull: true,
        remark: "点赞数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "belittle_num",
        type: "int",
        notNull: true,
        remark: "点踩数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "collect_num",
        type: "int",
        notNull: true,
        remark: "收藏数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "share_num",
        type: "int",
        notNull: true,
        remark: "分享数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "report_num",
        type: "int",
        notNull: true,
        remark: "举报数量",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        name: "read_seconds",
        type: "smallint",
        notNull: true,
        remark: "阅读耗时（计算：7字秒）",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        type: "decimal",
        length: 4,
        decimal: 2,
        remark: "分数，最小0，最大10",
        defaultValue: "10.00",
        name: "score",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "审核Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "audit_id",
        defaultValue: 0,
      },
      {
        type: "tinyint",
        name: "status",
        length: 1,
        notNull: true,
        remark: "启用状态",
        defaultValue: 1,
        isUnsigned: true,
      },
      {
        name: "visible_type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        defaultValue: 0,
        remark: "可见状态 注：0私密 1仅指定用户可见 2仅粉丝可见 3公开",
        enums: {
          0: "私密",
          1: "仅指定用户可见",
          2: "仅粉丝可见",
          3: "公开",
        },
      },
      {
        type: "json",
        remark: "分类标签",
        name: "tags",
      },
      {
        type: "json",
        remark: "历史记录Id",
        name: "history_id",
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "笔记",
    insertRows: [
      [
        "id",
        "title",
        "topic_ids",
        "createId",
        "exposure_num",
        "view_num",
        "comment_num",
        "praise_num",
        "belittle_num",
        "collect_num",
        "share_num",
        "report_num",
        "tags",
      ],
      [1, "这是笔记标题1", "[1,3,5,6,7,9]", 1, 12323, 12, 11, 82, 23, 23, 39, 6, "[1,2,3]"],
      [2, "这是笔记标题2", "[2,4,6,8,10]", 2, 12, 10, 20, 30, 40, 10, 20, 9, "[6]"],
      [3, "这是笔记标题3", "[1,2,3]", 3, 2, 1, 3, 4, 6, 7, 9, 1, "[1,6]"],
      [4, "这是笔记标题4", "[5,2,6]", 4, 0, 0, 0, 0, 0, 0, 0, 0, "[1,6]"],
      [5, "这是笔记标题5", "[2,4,2,4,6]", 5, 0, 0, 0, 0, 0, 0, 0, 0, "[1,6]"],
      [6, "这是笔记标题6", "[4,2,6,8,9]", 6, 0, 0, 0, 0, 0, 0, 0, 0, "[4,5,6]"],
      [7, "这是笔记标题7", "[1,2,4]", 6, 0, 0, 0, 0, 0, 0, 0, 0, "[2,3,5]"],
      [8, "这是笔记标题8", "[4,5,7]", 6, 0, 0, 0, 0, 0, 0, 0, 0, "[1,5,6]"],
      [9, "这是笔记标题9", "[2,4,1,8]", 6, 0, 0, 0, 0, 0, 0, 0, 0, "[6]"],
      [10, "这是笔记标题10", "[2,4,1,8]", 6, 0, 0, 0, 0, 0, 0, 0, 0, "[5]"],
    ],
  },
  tag: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "主键Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "标签类型 注：1文章/题目 2用户",
        enums: {
          1: "文章/题目",
          2: "用户",
        },
        defaultValue: 1,
      },
      {
        type: "varchar",
        length: 16,
        name: "name",
        remark: "标签名称",
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "int",
        remark: "最后修改人",
        isUnsigned: true,
        defaultValue: 0,
        name: "update_id",
      },
      {
        type: "datetime",
        remark: "修改时间",
        name: "update_time",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "标签",
    insertRows: [
      ["type", "name", "create_id", "update_id"],
      [1, "前端", 1, 1],
      [1, "CSS", 2, 1],
      [1, "JavaScript", 1, 1],
      [1, "TypeScript", 2, 1],
      [1, "NodeJS", 2, 3],
      [2, "资深作者", 4, 2],
      [2, "萌新观众", 3, 2],
    ],
  },
  audit: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "主键Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "审核类型 注：1文章 2笔记 3用户认证",
        enums: {
          1: "文章",
          2: "笔记",
          3: "用户认证",
        },
        defaultValue: 1,
      },
      {
        type: "tinyint",
        length: 1,
        remark: "审核状态",
        isUnsigned: true,
        name: "audit_status",
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "int",
        remark: "最后修改人",
        isUnsigned: true,
        defaultValue: 0,
        name: "update_id",
      },
      {
        type: "datetime",
        remark: "修改时间",
        name: "update_time",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "审核",
  },
  attitude: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "表态Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "target_type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "表态对象类型 注：1笔记（文章） 2题目",
        enums: {
          1: "笔记（文章）",
          2: "题目",
        },
        defaultValue: 1,
      },
      {
        name: "attitude_type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "表态类型 注：1点赞 2点踩 3收藏 4分享 5举报 6评论",
        enums: {
          1: "点赞",
          2: "点踩",
          3: "收藏",
          4: "分享",
          5: "举报",
          6: "评论",
        },
        defaultValue: 1,
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "表态",
  },
  feedback: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "反馈Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "varchar",
        length: 500,
        name: "advice",
        remark: "意见描述",
      },
      {
        name: "type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "反馈类型 注：0其他 1用户体验 2程序BUG 3平台建议",
        enums: {
          0: "其他",
          1: "用户体验",
          2: "程序BUG",
          3: "平台建议",
        },
        defaultValue: 0,
      },
      {
        name: "status",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "反馈状态 注：0待审核 1接受 2忽略",
        enums: {
          0: "待审核",
          1: "接受",
          2: "忽略",
        },
        defaultValue: 0,
      },
      {
        type: "json",
        remark: "图片描述",
        name: "imgs",
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "意见反馈",
  },
  report: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "举报Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "举报类型 注：0其他 1低俗色情 2内容抄袭 3涉嫌违法 4恶意营销 11名誉 12隐私 13著作 14肖像权",
        enums: {
          0: "其他",
          1: "低俗色情",
          2: "内容抄袭",
          3: "涉嫌违法",
          4: "恶意营销",
          11: "名誉",
          12: "隐私",
          13: "著作",
          14: "肖像权",
        },
        defaultValue: 0,
      },
      {
        name: "status",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "举报状态 注：0待审核 1接受 2忽略 3驳回",
        enums: {
          0: "待审核",
          1: "接受",
          2: "忽略",
          3: "驳回",
        },
        defaultValue: 0,
      },
      {
        type: "varchar",
        length: 500,
        name: "reason",
        remark: "举报原因",
      },
      {
        type: "json",
        remark: "图片描述",
        name: "imgs",
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "举报",
    insertRows: [
      ["type", "reason"],
      [0, "因为xxxx"],
      [1, "没有更多原因"],
      [2, ""],
      [3, ""],
      [4, ""],
      [11, ""],
      [12, ""],
      [13, ""],
      [14, ""],
    ],
  },
  notice: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "消息Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "消息类型 注：0系统消息 1点赞 2点踩 3收藏 4分享 5举报 6评论 7新增粉丝 8私信",
        enums: {
          0: "系统消息",
          1: "点赞",
          2: "点踩",
          3: "收藏",
          4: "分享",
          5: "举报",
          6: "评论",
          7: "新增粉丝",
          8: "私信",
        },
        defaultValue: 0,
      },
      {
        name: "status",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "已读状态 注：0未读 1已读",
        enums: {
          0: "未读",
          1: "已读",
        },
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "接收消息的用户Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "user_id",
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "notice",
  },
  orders: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "订单Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "用户Id",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "user_id",
        NotNull: true,
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        isPrimaryKey: false,
        remark: "商品Id（套餐Id）",
        isAutoIncrement: false,
        isUnsigned: true,
        isFillZero: false,
        name: "goods_id",
        NotNull: true,
        defaultValue: 0,
      },
      {
        type: "char",
        length: 19,
        remark: "订单编号",
        name: "order_no",
        NotNull: true,
      },
      {
        name: "pay_type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "支付方式（类型） 注：1金币 2人民币",
        enums: {
          1: "金币",
          2: "人民币",
        },
        defaultValue: 1,
      },
      {
        name: "amount",
        type: "tinyint",
        notNull: true,
        remark: "套餐份数",
        defaultValue: 1,
        isUnsigned: true,
      },
      {
        type: "decimal",
        length: 3,
        decimal: 2,
        remark: "折扣率",
        defaultValue: "1.00",
        name: "ratio",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "datetime",
        remark: "支付时间",
        name: "pay_time",
      },
      {
        type: "datetime",
        remark: "到期时间",
        name: "expire_time",
      },
      {
        name: "status",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "支付状态 注：0未支付 1已支付 2已取消",
        enums: {
          0: "未支付",
          1: "已支付",
          2: "已取消",
        },
        defaultValue: 0,
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "订单",
    insertRows: [
      ["goods_id", "userId", "order_no"],
      [1, 1, "2589224233526742751"],
      [2, 2, "2589224233526742752"],
      [1, 2, "2589224233526742753"],
      [2, 1, "2589224233526742754"],
      [1, 2, "2589224233526742755"],
      [1, 1, "2589224233526742756"],
      [2, 2, "2589224233526742757"],
      [1, 2, "2589224233526742758"],
      [1, 3, "2589224233526742759"],
    ],
  },
  set_meals: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "套餐Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "type",
        type: "tinyint",
        length: 2,
        notNull: true,
        isUnsigned: true,
        remark: "商品类型 注：0存储空间 1普通会员 2超级会员 4金币 5精力",
        enums: {
          0: "存储空间",
          1: "普通会员",
          2: "超级会员",
          4: "金币",
          5: "精力",
        },
        defaultValue: 0,
      },
      {
        name: "amount",
        type: "int",
        notNull: true,
        remark: "存储空间（G）、会员时长（小时、天）、金币数量（个）、精力数量（点）",
        defaultValue: 0,
        isUnsigned: true,
      },
      {
        type: "varchar",
        length: 100,
        name: "produce",
        remark: "套餐描述",
      },
      {
        type: "decimal",
        length: 5,
        decimal: 2,
        notNull: true,
        remark: "现价",
        defaultValue: "0.00",
        isUnsigned: true,
        name: "now_price",
      },
      {
        type: "decimal",
        length: 5,
        decimal: 2,
        notNull: true,
        remark: "原价",
        defaultValue: "0.00",
        isUnsigned: true,
        name: "old_price",
      },
      {
        type: "tinyint",
        name: "status",
        length: 1,
        notNull: true,
        remark: "启用状态",
        defaultValue: 1,
        isUnsigned: true,
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "int",
        remark: "最后修改人",
        isUnsigned: true,
        defaultValue: 0,
        name: "update_id",
      },
      {
        type: "datetime",
        remark: "修改时间",
        name: "update_time",
      },
      {
        type: "varchar",
        length: 50,
        remark: "备注",
        name: "remark",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "套餐",
    insertRows: [
      ["type", "amount", "old_price", "now_price"],
      [0, 1, 2, 1],
      [1, 1, 2, 1],
      [2, 1, 12, 9.9],
      [1, 1, 28, 19],
      [2, 1, 46, 39],
      [5, 1, 46, 39],
    ],
  },
  operate_status: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "操作Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "操作类型 注：12点赞 13点踩 14收藏 15分享 16评论 17私信 18举报",
        enums: {
          12: "点赞",
          13: "点踩",
          14: "收藏",
          15: "分享",
          16: "评论",
          17: "私信",
          18: "举报",
        },
        defaultValue: 12,
      },
      {
        type: "tinyint",
        name: "status",
        length: 1,
        notNull: true,
        remark: "是否操作过（0否1是）",
        defaultValue: 1,
        isUnsigned: true,
      },
      {
        type: "int",
        notNull: true,
        remark: "创建人",
        isUnsigned: true,
        defaultValue: 0,
        name: "create_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "创建时间",
        name: "create_time",
      },
      {
        type: "datetime",
        remark: "修改时间",
        name: "update_time",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "操作状态",
    indexNames: ["create_id", "type"],
    insertRows: [
      ["type", "status", "createId"],
      [12, 1, 1],
      [13, 1, 2],
      [14, 0, 3],
      [15, 1, 4],
      [16, 1, 5],
      [17, 0, 6],
      [18, 0, 7],
    ],
  },
  operate_log: {
    sqlFields: [
      {
        type: "int",
        notNull: true,
        isPrimaryKey: true,
        remark: "日志Id",
        isAutoIncrement: true,
        isUnsigned: true,
        isFillZero: false,
        name: "id",
      },
      {
        name: "business",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "所属类型 注：0业务1 1业务2",
        enums: {
          0: "业务1",
          1: "业务2",
        },
        defaultValue: 0,
      },
      {
        name: "operate_type",
        type: "tinyint",
        length: 1,
        notNull: true,
        isUnsigned: true,
        remark: "操作类型 注：0创建 1删除",
        enums: {
          0: "创建",
          1: "删除",
        },
        defaultValue: 0,
      },
      {
        type: "int",
        notNull: true,
        remark: "操作人Id",
        isUnsigned: true,
        defaultValue: 0,
        name: "operate_id",
      },
      {
        type: "datetime",
        defaultValue: "CURRENT_TIMESTAMP",
        notNull: true,
        remark: "操作时间",
        name: "operate_time",
      },
    ],
    formItems: [],
    tableCols: [],
    addEditFormItems: [],
    name: "操作日志",
  },
};
